package bp.App.Handler;

import javax.print.DocFlavor;

public class TemplateSql {

    //海口市行政代码
   public static  final String HKS="460100";
   public static  final String HKSQSQ="460107";
   public static  final String HKSQSQTBS="HKSQSQTBS";
   public static  final String HKSLHQ="460106";
   public static  final String HKSLHQTBS="HKSLHQTBS";
   public static  final String HKSXYQ="460105";
   public static  final String HKSXYQTBS="HKSXYQTBS";
   public static  final String HKSMLQ="460108";
   public static  final String HKSMLQTBS="HKSMLQTBS";
   //三亚市行政代码
   public static  final String SYS="460200";
   //S三亚市崖州区
   public static  final String SYSYZQ="460205";
   public static  final String SYSYZQTBS="SYSYZQTBS";
   //三亚市海棠区
   public static  final String SYSHTQ="460202";
   public static  final String SYSHTQTBS="SYSHTQTBS";
   //三亚市天涯区
   public static  final String SYSTYQ="460204";
   public static  final String SYSTYQTBS="SYSTYQTBS";
   //三亚市吉阳区
   public static  final String SYSJYQ="460203";
   public static  final String SYSJYQTBS="SYSJYQTBS";
   //三亚市育才生态区
   public static  final String SYSYCSTQ="460208";
   public static  final String SYSYCSTQTBS="SYSYCSTQTBS";
   //五指山市行政代码
   public static  final String WZSS="469001";
   //琼海市行政代码
   public static  final String QHS="469002";
   //儋州市行政代码
   public static  final String DZS="460400";
   //文昌市行政代码
   public static  final String WCS="469005";
   //万宁市行政代码
   public static  final String WNS="469006";
   //东方市行政代码
   public static  final String DFS="469007";
   //定安县行政代码
   public static  final String DAX="469021";
   //屯昌县行政代码
   public static  final String TCX="469022";
   //澄迈县
   public static  final String CMX="469023";
   //临高县
   public static  final String LGX="469024";
   //白沙县
   public static  final String BSX="469025";
   //昌江县
   public static  final String CJX="469026";
   //乐东县
   public static  final String LDX="469027";
   //陵水县
   public static  final String LSX="469028";
   //保亭县
   public static  final String BTX="469029";
   //琼中县
   public static  final String QZX="469030";
   public static   String HKSRWMJ="HKSRWMJ";
   public static   String SYSRWMJ="SYSRWMJ";
   public static   String WZSSRWMJ="WZSSRWMJ";
   public static   String QHSRWMJ="QHSRWMJ";
   public static   String DZSRWMJ="DZSRWMJ";
   public static   String WCSRWMJ="WCSRWMJ";
   public static   String WNSRWMJ="WNSRWMJ";
   public static   String DFSRWMJ="DFSRWMJ";
   public static   String DAXRWMJ="DAXRWMJ";
   public static   String TCXRWMJ="TCXRWMJ";
   public static   String CMXRWUMJ="CMXRWUMJ";
   public static   String LGXRWMJ="LGXRWMJ";
   public static   String BSXRWMJ="BSXRWMJ";
   public static   String CJXRWUMJ="CJXRWUMJ";
   public static   String LDXRWMJ="LDXRWMJ";
   public static   String LSXRWMJ="LSXRWMJ";
   public static   String BTXRWMJ="BTXRWMJ";
   public static   String QZXRWMJ="QZXRWMJ";
   public static   String HJRWMJ="HJRWMJ";
   public static   String LHQTBS="LHQTBS";
   public static   String MLQTBS="MLQTBS";
   public static   String QSQTBS="QSQTBS";
   public static   String XYQTBS="XYQTBS";
   public static   String HTQTBS="HTQTBS";
   public static   String JYQTBS="JYQTBS";
   public static   String TYQTBS="TYQTBS";
   public static   String YCSSTQTBS="YCSSTQTBS";
   public static   String YZQTBS="YZQTBS";
   public static   String WZSSTBS="WZSSTBS";
   public static   String QHSTBS="QHSTBS";
   public static   String DZSTBS="DZSTBS";
   public static   String WCSTBS="WCSTBS";
   public static   String WNSTBS="WNSTBS";
   public static   String DFSTBS="DFSTBS";
   public static   String DAXTBS="DAXTBS";
   public static   String TCXTBS="TCXTBS";
   public static   String CMXTBS="CMXTBS";
   public static   String LGXTBS="LGXTBS";
   public static   String BSXTBS="BSXTBS";
   public static   String CJXTBS="CJXTBS";
   public static   String LDXTBS="LDXTBS";
   public static   String LSXTBS="LSXTBS";
   public static   String BTXTBS="BTXTBS";
   public static   String QZXTBS="QZXTBS";
   public static   String HKSTBS="HKSTBS";
   public static   String SYSTBS="SYSTBS";
   public static   String HJTBS="HJTBS";
   public static   String HJCDTBS="HJCDTBS";
   public static   String HJCXTBS="HJCXTBS";
   public static   String HKSPJTBMJ="HKSPJTBMJ";
   public static   String SYSPJTBMJ="SYSPJTBMJ";
   public static   String WZSSPJTBMJ="WZSSPJTBMJ";
   public static   String QHSPJTBMJ="QHSPJTBMJ";
   public static   String DZSPJTBMJ="DZSPJTBMJ";
   public static   String WCSPJTBMJ="WCSPJTBMJ";
   public static   String WNSPJTBMJ="WNSPJTBMJ";
   public static   String DFSPJTBMJ="DFSPJTBMJ";
   public static   String DAXPJTBMJ="DAXPJTBMJ";
   public static   String TCXPJTBMJ="TCXPJTBMJ";
   public static   String CMXPJTBMJ="CMXPJTBMJ";
   public static   String LGXPJTBMJ="LGXPJTBMJ";
   public static   String BSXPJTBMJ="BSXPJTBMJ";
   public static   String CJXPJTBMJ="CJXPJTBMJ";
   public static   String LDXPJTBMJ="LDXPJTBMJ";
   public static   String LSXPJTBMJ="LSXPJTBMJ";
   public static   String BTXPJTBMJ="BTXPJTBMJ";
   public static   String QZXPJTBMJ="QZXPJTBMJ";
   public static   String HJPJTBMJ123="HJPJTBMJ";
    public  static final String RWMJSQL="select  sum(jdmj),shuoshusx,count(*) as tbs  from gis_basicinfo GROUP BY shuoshusx";
    public  static final String SXRWMJSQL="select  newDT.sum  from  (select  sum(jdmj),shuoshusx  from gis_basicinfo GROUP BY shuoshusx) as newDT where newDT.shuoshusx='%S'";
    public  static final String HKSQXTBS="select  quxianno,count(*) as tbs  from gis_basicinfo where shuoshusx='460100' GROUP BY quxianno";
    public  static final String SYSQXTBSSQL="select  quxianno,count(*) as tbs  from gis_basicinfo where shuoshusx='460200' GROUP BY quxianno";
    public  static final String CDTBSSQL="select  quxianno,count(*)  from  gis_basicinfo where jdmj >%S  GROUP BY quxianno";
    public  static final String CXTBSSQL="select  quxianno,count(*)  from  gis_basicinfo where jdmj <=%s  GROUP BY quxianno";


}
